SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 40
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Looking for a property that truly has it all? Look no further than 376 Orford Road, in the coveted town of Lyme, NH. With 4,500 square feet of wonderfully comfortable and functional living space, the first floor offers a primary en suite bedroom, 2 additional bedrooms and bathrooms, a large living room, spacious eat-in kitchen, mudroom and laundry. The lower level includes a media room, recreation room, exercise room and office. Attached to the main residence, and with its own entrance as well, is a two story auxiliary dwelling unit equipped with a full eat-in kitchen, living room, laundry, 3/4 bathroom and private deck - ideal for in-laws, a nanny or rental opportunity. The back of the home connects to the level, landscaped, and fenced-in backyard area with a hot tub, in-ground pool, and pool house - ideal for relaxing or entertaining. The oversized 3 car garage has an upper level that could easily be finished off for additional living space, or is ideal "as is" for a home office or business storage. The abutting conserved land offers lovely pastoral views and westerly sunsets. Rounding out the property is another large outbuilding and separate shed for all your storage needs. Lyme is home to one of the most highly rated K - 8th grade schools in the state and is a short drive to Hanover, Dartmouth College and Dartmouth Health. Don't miss this incredible opportunity for a property that has everything you want, and more.
Description:DRUM ROLL PLEASE!! A pleasure and a privilege to introduce this GEM - AIA Vermont Design Award 2004 winner. The design and cleverly sited Contemporary waterfront home embodies flair, creative use of space, ingenuity, workmanship, charm and a WOW factor from the minute you enter the door. Light filled, open floor plan on the main level with great large windows, living room with two-way fireplace, with black marble lintel, extends the indoor to outdoor living space on an amazing screened porch complete with views to the Lake and the Knox River at Shaker Boulevard!! AND THEN The Cottage House!! This is another GEM, totally renovated with a well thought out floor plan consisting of one bedroom, kitchen, living/dining area, 1.5 bathrooms, full basement and an amazing wraparound porch with VIEWS, up the Lake and all around!! To describe the setting: Private, level, beach area, docks and an estuary to watch the birds and ecosystem of life survive. This is a must see!!
Description:Don't miss out on this incredible opportunity to own a beautiful commercial/residential zoned property in a highly visible area of Hanover, NH. Ideallysituated right on Route 10 (Lyme Road), just minutes from downtown Hanover and within walking distance of the elementary and middle schools, this property features agorgeous post and beam building connected by a breezeway to an additional building, with plenty of parking. Constructed by the renowned Timberpeg builders, the mainbuilding offers 3 levels of finished space, including a vaulted ceiling entryway suffused with natural light, a suite of offices, most of which feature en-suite bathrooms, aspacious shared kitchen, and a media room. The smaller building is a versatile 2-story space, originally built as a squash court, but ripe for use as a yoga studio, retailspace, or apartments. The newer zoning status allows for 49% of the buildings to be converted into residential living space, opening up endless possibilities for a buyer.This property has been beautifully maintained and updated over time, including a high-efficiency pellet boiler to help reduce expenses and carbon footprint. Take advantage of this unique Hanover offering and bring your ideas!
Description:ADAPTIVE REUSE OPPORTUNITY – 25 ACRE ORGANIC HOMESTEAD located within 2 hours of Boston! Welcome to the former home of the renowned D Acres Permaculture Farm & Educational Center. Cultivate a working farm, a restaurant, a family compound, an event or wedding venue. This property offers the space and soul to support an array of visions. The heart of the main building features a commercial kitchen with indoor and outdoor dining space. A network of beautiful rooms with mountain views on the second and third floors accommodate more than 15 guests at a time. This land has been lovingly shaped with intention – featuring orchards of mature fruit trees, perennial gardens, open fields, and natural systems designed for long-term abundance. Additional building sites with breathtaking mountain vistas offer extraordinary possibilities for expansion or subdivision. A rare sense of peace & privacy. Located within 30 minutes of I-93. A truly unique opportunity. This is what legacies are made of.
Description:Nestled along the serene shores of Eastman Lake in the sought-after four-season Eastman Community, this fully renovated three-bedroom waterfront home offers a perfect blend of modern comfort, natural beauty, and a touch of Adirondack style. Step inside to discover a stunning new kitchen featuring gleaming stainless-steel appliances, including a 3-foot gas cooktop—ideal for the home chef—along with a wall oven, microwave, and wet bar. Custom built-in cherry cabinetry enhances both the kitchen and living room, while a full-height stone fireplace with a custom cherry mantel creates a warm and inviting focal point. Each level offers an updated bath, including a beautifully appointed primary bath that stands out as a private retreat. A second kitchen adds exceptional flexibility, making it easy to entertain guests while enjoying the hot tub or dining outdoors. Beyond the walls, the thoughtfully designed, tiered landscape features stone steps, walkways, and curated plantings, all leading to a peaceful path to the lake. In just a short walk, you can be relaxing on one of Eastman’s inviting beaches. Living in Eastman means embracing a true four-season lifestyle. Residents enjoy access to a championship golf course, indoor pool, fitness center, tennis and pickleball courts, as well as cross-country skiing, snow shoeing, hiking, and biking trails. The centerpiece is the 345-acre lake with six beaches, offering endless opportunities for recreation and relaxation. Unwind at the water’s edge or take in expansive lake views from your private deck—this is lakeside living at its finest. Seller is a licensed real estate agent.